if exists (select 1
            from  sysobjects
           where  id = object_id('bd_schedule_receive')
            and   type = 'U')
   drop table bd_schedule_receive
go

/*==============================================================*/
/* Table: bd_schedule_receive                                   */
/*==============================================================*/
create table bd_schedule_receive (
   id                   bigint               identity,
   user_no              varchar(50)          null,
   user_name            varchar(100)         null,
   rq                   varchar(7)           null,
   d1                   varchar(100)         null,
   d2                   varchar(100)         null,
   d3                   varchar(100)         null,
   d4                   varchar(100)         null,
   d5                   varchar(100)         null,
   d6                   varchar(100)         null,
   d7                   varchar(100)         null,
   d8                   varchar(100)         null,
   d9                   varchar(100)         null,
   d10                  varchar(100)         null,
   d11                  varchar(100)         null,
   d12                  varchar(100)         null,
   d13                  varchar(100)         null,
   d14                  varchar(100)         null,
   d15                  varchar(100)         null,
   d16                  varchar(100)         null,
   d17                  varchar(100)         null,
   d18                  varchar(100)         null,
   d19                  varchar(100)         null,
   d20                  varchar(100)         null,
   d21                  varchar(100)         null,
   d22                  varchar(100)         null,
   d23                  varchar(100)         null,
   d24                  varchar(100)         null,
   d25                  varchar(100)         null,
   d26                  varchar(100)         null,
   d27                  varchar(100)         null,
   d28                  varchar(100)         null,
   d29                  varchar(100)         null,
   d30                  varchar(100)         null,
   d31                  varchar(100)         null,
   bh                   varchar(20)          not null,
   constraint PK_BD_SCHEDULE_RECEIVE primary key (id)
)
go

if exists (select 1 from  sys.extended_properties
           where major_id = object_id('bd_schedule_receive') and minor_id = 0)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '排班管理-导入临时表',
   'user', @CurrentUser, 'table', 'bd_schedule_receive'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'id')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'id'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   'id',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'id'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'user_no')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'user_no'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '工号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'user_no'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'user_name')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'user_name'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '姓名',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'user_name'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'rq')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'rq'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '日期',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'rq'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd1')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd1'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '1号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd1'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd2')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd2'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '2号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd2'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd3')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd3'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '3号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd3'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd4')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd4'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '4号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd4'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd5')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd5'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '5号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd5'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd6')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd6'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '6号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd6'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd7')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd7'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '7号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd7'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd8')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd8'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '8号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd8'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd9')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd9'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '9号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd9'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd10')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd10'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '10号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd10'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd11')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd11'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '11号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd11'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd12')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd12'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '12号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd12'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd13')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd13'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '13号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd13'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd14')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd14'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '14号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd14'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd15')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd15'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '15号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd15'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd16')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd16'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '16号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd16'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd17')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd17'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '17号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd17'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd18')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd18'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '18号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd18'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd19')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd19'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '19号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd19'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd20')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd20'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '20号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd20'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd21')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd21'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '21号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd21'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd22')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd22'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '22号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd22'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd23')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd23'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '23号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd23'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd24')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd24'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '24号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd24'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd25')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd25'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '25号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd25'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd26')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd26'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '26号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd26'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd27')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd27'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '27号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd27'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd28')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd28'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '28号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd28'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd29')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd29'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '29号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd29'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd30')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd30'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '30号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd30'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'd31')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd31'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '31号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'd31'
go

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('bd_schedule_receive')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'bh')
)
begin
   declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'bh'

end


select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
   '编号',
   'user', @CurrentUser, 'table', 'bd_schedule_receive', 'column', 'bh'
go
